package com.njtoyo.taxi.admin.mapper.secondary.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.njtoyo.taxi.admin.library.Const;
import com.njtoyo.taxi.admin.mapper.secondary.entity.cache.CacheDriverWorkingCanton;
import com.njtoyo.taxi.admin.mapper.secondary.enums.CacheDriverWorkingType;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.Date;
import java.util.List;

/**
 * <p>
 * 司机出车统计 Mapper 接口
 * </p>
 *
 * @author Dell
 * @since 2022-04-06
 */
@Repository
@DS(Const.SECONDARY_DS)
public interface CacheDriverWorkingCantonMapper extends BaseMapper<CacheDriverWorkingCanton> {
    List<CacheDriverWorkingCanton> selectWorkingTaxiRateGroupByCanton(@Param("type") CacheDriverWorkingType type, @Param("startTime") Date startTime, @Param("endTime") Date endTime);

    List<CacheDriverWorkingCanton> selectWorkingTaxiCountGroupByCanton(@Param("type") CacheDriverWorkingType type, @Param("startTime") Date startTime, @Param("endTime") Date endTime);

    List<CacheDriverWorkingCanton> selectWorkingTaxiTotalCountGroupByCanton(@Param("type") CacheDriverWorkingType type, @Param("startTime") Date startTime, @Param("endTime") Date endTime);
}
